For doing water scenes, SeaVue is by far the best thing going. The materials are very easy to use and come with great tips and comments on each of the materials. I use them on almost every water scene I create - I highly recommend it. You can get SeaVue over at 3D Commune.