Nearly half of treated water goes waste in city