Contributions toward net-zero carbon in the water sector: application to a case study