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.