Rainwater harvesting (RWH) is analyzed in this work as an option for water supply for places with over-exploited water resources. The model is formulated under a multi-period, multi-objective optimization model. The objective is two fold, first to assess the potential of RWH as an alternative water source, and second to design an optimal water distribution network in which both natural and alternative sources work as an integrated system. The problem is formulated to account for three different objectives, namely maximum profit, minimum groundwater usage and minimum investment cost. A case study for the city of Queretaro in Mexico was considered to show the applicability of the proposed approach. The results show that as much as 27% of the domestic demand in Queretaro City could be supplied by RWH, which would lead to a significant recovery of deep wells currently under depletion. (C) 2018 Elsevier Ltd. All rights reserved.