West Midlands to become 'wet and windy' as UK prepares for 'heaviest rain and strongest winds' this autumn