I really like that it's not just a "static" fountain, but it's animated to grow and shrink. Way more difficult that "just" having it in one state all the time.
If you're interested in making VFX in Blender, Azra provides several tutorials which surely can also be an inspiration on how to transfer the knowledge into Godot, Unreal, Unity, CryEngine or Ogre.
I know, math appears scary. I shared nice artist friendly resources in newsletter #11 already, and here is another one. Yes, the author is called Simon, but it's not me!
Phillip Stoltz released his tutorials for free. It's not about VFX, but I have a thing for stone sculpts! Of course, this knowledge can become handy, when one is in need for a nice impact decal!