For the third time - no transparency. That does not bend the light. Water bends the light. You want to use refraction.

Here is a basic (no waves) water setup using Fresnel_Blend. The Fresnel_Blend node determines the amount of reflection versus refraction according to the Fresnel reflection coefficient equation. (i.e. real life)

Turn off shadows for the water prop and put this shader in.

Once you get to this, then you can experiment with waves in the bump channel.

However, that will be many days of discussion, so start with simple water and get used to that. I bet you will still have questions or do things wrong.

For example, I repeat: TURN OFF SHADOWS FOR THE WATER PROP.

Also: You need to enable raytracing and have at least 1 bounce.

Also: You will need a full 3D environment behind the water (at least an environment sphere) for it to reflect things like the sky.

---

Renderosity forum reply notifications are wonky. If I read a follow-up in a thread, but I don't myself reply, then notifications no longer happen AT ALL on that thread. So if I seem to be ignoring a question, that's why. (Updated September 23, 2019)