you could try some light transparency - and on the part that it is flowing down, put some small rocks protruding from the drop, that may make it look a little more realistic, cause you'd be able to see the rock scape underneath the water!