Access to domestic water supply is a big challenge to many households in developing countries, as a large number of households do not have access to municipal water sources. The purpose of this study is to investigate the nature of access and characteristics of water sources and their impact on the choice and usage of water by providing empirical and statistical evidence. A survey of 1,300 households was conducted across six major cities in Southwest Nigeria, using structured questionnaires, field surveys, personal interviews, and observations. The data obtained were analysed using SPSS 27 for descriptive statistics and characterised using enhancement-based strategies. The result showed that access to pipe water was 5%, 66% used private wells and boreholes, and 29% used off-site water sources. The study discovered that 15 different water sources with unique attributes were consumed. The daily consumption ranged between 301 and 361 and 1,153 and 1,421 litres per household (L/hh/d) for those using off-site and on-site water sources, respectively. This study provides new insights with empirical evidence. As such, there is a need to re-evaluate the present water supply policy implementation, funding approach, and level of coverage. Additional policies that support and fund decentralised water projects, without compromising on water quality, should be provided, since they are more accessible to the people.