there are a few tutorials where you make a water flow like in a shower. Im sure if you adjusted it correctly you could add it to the side of a cliff to make it a waterfall. check tutorialized.com they have different tutorials but they are somewhat hard to follow as far as what work flow they used.