Thanks guys. The transparency was quite easy to do with Photoshop and no additional rendering sotware is needed. You just paint using blue and black brushes with low opacity (10% or so). The more you paint the less you see through. Then just apply the water texture and waves and you are done.