They are in the process of building a rock waterfall on my pool now. (new pool) I dont think you will get enough flow with clear tubing. We had to add three very large suction drains at the bottom of the pool in order to have enough water to go over the falls, otherwise you will just have wet rock.