I can’t take credit for the waterfall, but will say it was one of the two things about the property that sealed the deal. The other was the beehive fireplace. I have recently resurfaced to pond and have replaced the pump a few times over the years but it has certainly been a great feature. The cats love it when the water is not running. The waterfall is automated and can be switched or timer controlled. I added the wall of flagstone around the waterfall to prevent my dessert tortoise from getting in. However, I think it looks nicer with than without even though the tortoise is no longer with us.
Her den is still part of the back yard if one were to consider.