You would be looking at the F1 help and then the fluid section. That is if you have unlimited. If you don't then you have to do it the old fashioned (and faster rendering) way with geometry and shaders. Look at kbrowns Andrea Gail thread for an example of stormy water.