Record-setting rain from the storm that killed at least five people has caused flash flooding in some of America’s most historic Southern cities.