A weather system could bring catastrophic flooding across four states, beginning on Wednesday amid rounds of heavy rainfall.