Flood-hit areas to escape heavy rain as temperatures drop below freezing following 'biblical' downpour