the water in the scene is a simple flat poly plane with a mia_material using the default water preset and a simple bump map.

I can't remember if i show the shader or not, but it's a 30 second setup job. What makes water look realistic is the environment it's in, the water is pretty much just reflecting the things around it.

Hope that helps
David