Carrara is pretty good at water. Turbulence is a good modifier (used in the Bump channel in the top image) and, if you've got Shader Ops, the Fake Fresnel works well to give the varied transparency as in the bottom image.