The Met Office has issued an alert for New Year's Eve