Real-time management solution for water systems