More than 20,000 residents do not have access to running water in five of the top 15 biggest cities, a study revealed.