The weather is set to be unsettled in certain parts of the UK on New Year's Eve, with the Met Office warning those looking to celebrate of potential travel disruptions.