It's been forever since I've done this, but lots of bars (possibly including hotel bars) will sell tickets for NYE gala events, basically open bar for a few hours and food (heavy appetizers or a light buffet). You're probably looking at $150-200pp.
Agree with staying away from the Times Square area.