The Met Office has issued a rare amber warning for rain as much of the UK prepared for stormy weather.