I have read a lot of posts about water in this forum but none of them seem to be what I am looking for, except this one:
How can I create a water material in Cycles?:
Every time I try to re-make it though it looks all black.
I have tried a load of different material:
I have come up with, etc. The first picture below is what I am trying to make (if I could get that water to be correct, then I could tweak it and add the green/blue color like in the image above. 

