I did this simple loop of water splashing for a fountain.

It's basically one image stretched with the mesh deformation.

Not the ultimate best animation of water but using just one image instead of a frame by frame animation sequence when you are limited on the space for optimisation, I'm satisfied with the result.