A record summer in Sydney and a series of early-season heatwaves helped make 2017 the city's thirstiest year since 2004, Sydney Water said.