This attractive fountain is
called a "shishi odoshi", known in Japan as a deer scarer and to sushi
restaurants around the world as a bamboo rocking fountain.
I would be concerned about
how the noise signature and interval stay constant depending on the
water pressure. It's also got the obvious problem of freezing in the
winter.
It would be easy to fabricate
these from PVC pipe. This application might work if 3 or 4 of these
units were hooked up so that the noise was staggered and each one
created a slightly different clang. A possible solution for someone
with no electricity and a nearby source of running water that only
needs protection during the growing season.