All you need is a pump, a filter and some pipes, along with a nozzle to scatter the pressurized water in some aesthetically pleasing way. Fountains ... quite impressive: a jet of liquid metal ...