Above is a picture of the three pumps being used that powered the effects. They put out a hefty 1200 gallons a minute of flow. A average house well pump will move 12 gallons a minute.  Those pumps move water a thousand times faster than your standard well pump!
Above and below are pictures of the great big water fall and stream beds being built.
Below is a picture of the 45,000 gallon underground storage tank that the pumps went into. The pumps were hung off of the ceiling with 4″ threaded stainless steel piping. 45,000 gallons is bigger than two swimming pools!