There are a few photos floating around the net right now regarding a pipeline fish tank, or a fish highway. The fish highway is a concept that uses suction to elevate water out of a fish tank into an upper container.
I also recently posted a video of an open bottom aquarium that uses pretty much the exact same type of concept, just executed differently. This is interesting stuff.
As an aquarium hobbyist, I would actually rather not delve into this type of setup myself. There seems to be a decent amount of risk for a water spill. And when the water spills, there will be a lot of water spilling. I have a hard enough time maintaining a simple 75 gallon tank.