How to fix water texture render?

The first thing I notice is that your ior value in the glass shader is very high.

3.6 will be mirror like, try 1.5.
you can also mix your glass shader with a transparent shader (using a mix shader node) to control the overall transparency.