Working with mechanisms and levers, I started wondering why pipe sections aren't moving flows across my fortress in about the same way that levers link distant objects.
Take a pipe section and a building material of your choice, then build a floor pipe (like a floor), wall pipe (n/s/e/w) or ceiling pipe ('hangs' from the ceiling). Build another pipe at your destination, then link the two using pipe sections. Pipe sections will be required for every three or five tiles of separation between end points. Once linked, water flows into and out of the pipe structures, depending on the structure's orientation, as if those tiles were adjacent.
For example, a 7/7 tile of water on top of a floor pipe inside checks to flow down into the pipe, obeying pressure rules, to see if it can flow east out of an east wall pipe. If it can, it appears in the tile east of the wall pipe. Once the two have normalized, 4/7 and 3/7 water flows back and forth, normalizing the level. If one pipe entry is higher than the other, water flows down using the normal logic.
A pipe can also be linked to a screw pump to pour water directly into your destination.
The FPS savings for waterworks, water-hauling jobs and pump stacks could be phenomenal.
As an aside, the same distance-for-linkage logic could require levers and their linked mechanism to require chains/ropes.