Hey AustinVonDoom -
Here is an example of how to set up the material:
And here is the result in the Editor:
Jackie is absolutely right though that the water will be a Translucent material.
Thank You -
Eric Ketchum