Creating a realistic and natural looking water flow is still one of the biggest challenges in the world of animation. Check this amazing attempt by NVIDIA, it truly is mind-blowing.
If you were ever wondering how the heck do they create those continuous patterns, then wonder no more and check this neat Photoshop tutorial that might teach you a new designing trick or two.