CGRats has a great step-by-step tutorial with downloadable scenes on how to create and render Realistic Water in 3ds Max. Combining HDR with procedural textures, the end result is an amazing realistic image.
Realistic Water in 3DS Max – CGRats – Daily CG tutorials and resources.
