I did this several years ago using tile, rocks, broken pottery, and found items. At one point I had water cascading down it from copper tubing at the top, but it became difficult to get the calcium off so I removed that. It's on Hardy backer board and the frame is 2x4s so it's very heavy. Used quickset as the grout, adding more weight. It's not going anywhere!
