I think it could be pretty simple (although getting any animation going in a turn based thing can be tricky if it wasn't designed from the start)--even something as basic as a 2-frame animation that the character does when they cast the spell and a 1/5th of a second overlay on the affected square would do a ton.