The 'biggest free firework display' in the North East is set to return to Newcastle for the first time since 2019 to mark the beginning of 2025.