Downtown Raleigh's annual New Year's Eve celebration "Raleigh First Night
". Lots of entertainment all night long. You do have to purchase a ticket ($9 in advance / $12 day of event) but there does seem to be a lot of stuff to choose from. I have never been to this but hope to make it next year.
For More Info: Raleigh First Night Website
List of Entertainers: Link