How to make material semi-transparent in Cycles?
To make a semi transparent texture, place a diffuse and transparent shaders in the input of a mix node in the node editor.


To make water, use the glass shader and play around with the node values.