Text this: Robust adaptive optimization for sustainable water demand prediction in water distribution systems