A major upgrade of the city’s ageing sewerage system will also unlock housing development in south-west Sydney and could provide an environmentally friendly water source to data centres.