How to make an image fade out?

im trying to achieve this effect how would i accomplish this??? gradient transparent with what??? ( i want the bottom of the water to start fading out but i use transparent gradient and it looks tooo obvious

this is the image effect

here is the image!!