A state of emergency was declared after torrential rain and flooding left Mississippi’s largest city without running water, affecting over 100,000 people.