Use N+ water intake. It produces water magically, without needing to be connected to any water source. They can be placed anywhere you want and used for an infinite water supply, negating the need for long and aesthetically unattractive water pipes (which are not allowed anyways).