Its possible the manipulate the vertecies of a terrain directly,
its a slow approch tough, and better for just changing terrain
once (bomb crater or so)

You could also use multiple terrains that get turned on
one after another in a cycle. (more memory)

Not shure if there is an included terrain-animation setting now.

Better look for a better fog or whatever it is and use an animated model.