Design of advanced water supply and distribution systems