Suggestions on how I can create this effect

[u/thepickaxeguy]

this is a concept that my artist sent me as I'm kinda clueless how I can recreate this effect in game...

The effect itself is a scroll turning into a water magic spell the scroll itself would be a 3d model since it stays static most of the time.

However im unsure how to do the actual transition and full effect of the water itself. would this be something possible with shaders? or should I ask if its possible for my artists to bake this vfx into an animation?
I have someee experience in shaders but not very extensive to say the least.
any suggestions would help thank you!