Smart metering and data analytics enable the implementation of a range of onsite infrastructures for energy, water and waste management to demonstrate the interconnected infrastructure of future smart cities. A smart city funded project in Western Australia is integrating smart metering technology, household participation and data analytics. Better understanding of hybrid water systems at residential scale, as socially accepted solutions to promote water efficiency and economic savings, within the traditional centralised urban water network is achieved. An integrated water model and a system of water credits and debits is developed and tested on a case study for which 10-minute logged water consumption data of its hybrid water system are available for one year. The model is shown to provide a full characterization of the relationship between the household and the water resources, thus assisting with an improved urban water management which promotes the rollout of decentralized hybrid water systems whilst accounting for the impacts on the aquifer as an ecosystem service provider.