I have one (not in use atm, but I love it). It's a bought one, shaped like a lion's head fountain on a wall, I'm sure you've seen ones like it.
It works from an air pump which lifts up fine sand and then lets it drop down from the lion's mouth, where it falls through a grid and goes round to the beginning.
It's very cool when it's running.