Ripple Water is a simple, professional solution for great looking, efficient water.
Use any material and shader you want. No code required, everything is tweakable to get the effect and performance you need. Code is neat, commented, extensible and simple.
Comes with fully working demo scene and water shader.
Web Demo