Lagoa realistic water

[David Saber]

hello
Is there a tutorial or a video that could explain how to get realistic 
water? I'd like to get something like this:
http://vimeo.com/28915976
Can't seem to find the right settings tonight :(
Thanks
David