New Year's Eve fun
I'm not sure what type of celebration you might enjoy, but I think Scottsdale and Greater Phoenix probably has something for everyone.
Don't tell, but the years we stay home, I rarely stay awake for the New Year!

Really, we have spent several of our 25 NYE's in Scottsdale, so I'll try.
On Mill Street (Millennium Street, back in 1999/2000), very near ASU campus and stadium, there is an awesome street party. Lots of restaurants, bars, shops, sound stages set up,etc. Several blocks, lots to see, eat, and do. The Fiesta Bowl Teams used to participate in a parade, not sure if this still is the case. Our kids have fond memories of bringing in 2000 with us on Mill. I'll let you know about the parade and whether it's still appropriate for kids.
I'm sure there are black tie events at some of the resorts that you could make reservations to attend, if that's what you would enjoy.
Last year we came back to SDO and they provided hats and noise makers, cheese, crackers, a fruit tray, and chips. Kids attended (it was really only 10 PM when we "celebrated"). We watched as the ball dropped in Time's Square on the big screen. Talk about FUN!?! Kinda like being at home!
Have a safe one!