Cash-strapped cities are contending with aging, leak-prone water systems that waste trillions of gallons a year and result in damaging breaks.