Rain and cooler temperatures are forecast but experts warn some areas may ‘miss out’