Thank you.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