Heavy downpours and widespread flooding are expected across the country as weather alerts come into effect