This application demonstrates the realistic rendering of clean and foggy water, Fire and Sky. A tutorial about the water effect is included. It also features y-axis billboarding and simple collision detection/response.
You need a graphics card supporting Vertex & Fragment programs to see all of the effects.
OpenGL Water Tutorial