A family-friendly fireworks display and midnight event will be staged for revellers to see in 2025.