I work every NYE. Have for decades. Matter of fact one of our running jokes is that you can do just about anything you want on this job except show up late and have NYE off. So when the clock strikes 12 I'm not popping champagne corks, or blowing noisemakers - I'm making balloons drop, or creating confetti blizzards, bringing father time in on a line, or doing some gag.
If nothing else content yourself with the same notion that we have, that NYE (like St. Paddy's Day) is just amateur hour and its not missing much.
But is there some public deal, like the ball drop in NYC, or in SF they shoot off fireworks over the Bay or something like that?