all fountains are just tubing and water pump. you can basically do any design you want once you get the right tubes and pump. if you break down that picture, it actually looks simple (of course it is probably alot harder than i think it is). i guess the hard part is getting the water to flow out the way you want it to.
a large sheet of glass, a metal frame, rocks, and the bottom holder. you can probably put the pump on the bottom below the rocks so it is hidden, and run the tube up in the metal frame so nobody will see it.