I made extensive use of the loc-line pipe in my plumbing setup. They're terrific for directing water flow inside the aquarium. Note that they are not water-tight. IOW, they cannot be used outside the aquarium, only over or under water.
This pipe is available from MANY outlets in the US. Oceanic and Kent are just two of the brands.