Climate change is projected to have profound impacts on the resilience and sustainability of built infrastructure. This study aims to understand the impacts of climate change on water supply systems and to facilitate adaptive actions. A premium database maintained by the Cleveland Water Division, Cleveland, Ohio, USA is analyzed. It contains 29,621 pipe failure records of 51,832 pipes over the past 30 years, representing one of the largest dataset in current literature. From the database, pipe failure rate models have been developed for water pipes made of different types of materials at different ages. The influence of climate (temperature and precipitation) on fragility of water pipes are obtained. Based on the developed climate-fragility failure rate models, the impacts of climate change on the water systems located in different geographic regions are evaluated by predicting the failure rate and number of failures in the water systems in the next 80 years (2020 to 2100). Climate models are used to predict weather under different climate change scenarios. The results demonstrate that the impacts of climate change on water supply system are likely complicated and are dependent upon factors such as the geographic location, pipe material, pipe age, and maintenance strategies. Water pipes in the cold regions may experience fewer number breaks due to the warmer weather and less severe winter, whereas those located in the hot regions may experience more failures associated with more corrosion. Different pipe replacement strategies are compared, which demonstrate the importance of considering the aging of water supply system in future maintenance decisions. This study enriches current understandings on the impacts of climate change on the water systems. The results will help water utilities to design climate change adaptation strategies.