Pakistan is rapidly becoming a water stressed country, thus affecting people's well-being. Authorities are faced with making drastic water conservation policies toward achieving effective management of available water resources and efficient water supply delivery coupled with responsible demand side management. Due to the lack of modern water metering in Pakistan, water consumption is not being accurately monitored. To achieve this goal, we propose a hybrid modeling and simulation framework, consisting of: (i) Agent-Based Modeling (ABM) paradigm that deals with the behavior and characteristics of individuals and (ii) System Dynamics(SD) paradigm that accounts for water flow dynamics. Our approach provides dual-resolution expressiveness suitable for replicating real-world urban infrastructure scenarios. The key objective of the research is to assist authorities to understand and forecast short-term and long-term water consumption through examining varying patterns of water consumption in different climates and thus improving demand side water usage dynamically subject to water supply availability.