A weather expert has warned residents to "be alert" as spells of heavy and persistent rain are set to cause chaos on Sunday