Hmm, off the top of my head I think that it takes as much energy to pump water down a 1-foot tube as it would for a 1000-foot tube. It's like rotating a long loop of chain on a pulley, but in three dimensions. One liter of water goes down the tube, one liter of water comes up around the tube. Both sides weigh equal amounts so there's no net force. Of course, overcoming inertia to get the water moving and keeping it moving despite friction might be significant. Ironically, a consequence of the oil industry is that we have powerful pumps that are proven to be economical in moving large amounts of liquids long distances through pipes :)