The weather will become unsettled through Monday and Tuesday, with New Year's Eve seeing gales and downpours