New Year's Eve (NYE) will be celebrated with fireworks displays across the Northern Beaches tonight (Sunday, 31 December 2023).