Here is a nice water texture setting I've used for a couple of renders. It may or may not be transparent enough for many uses, but play around with the "alpha" setting until you've achieved the effect of your desire.