Residents weren’t fully convinced until the mayor himself drank the water they suspect is behind reports of widespread diarrhoea in the area since floods began