We lived in Aden from 1969 onwards till 1972. We never faced any water issues at all. It was always there straight from the tap and in the fridge in emptied orange squash bottles for cooling.
There was something about Aden water though, I always felt hungry and my mom often got tired of cooking all the time.