I did a cliffside on a commission some time back linked here that might give you some ideas. You would want to change the base to water if you want it to match the image you posted.