A special audit has exposed failing infrastructure, high losses and mismanaged municipal water services