Digital transformation for sustainable water supply