You'll have FUN.
If you haven't already, log on to
http://www.edinburghshogmanay.org/
Most Hotels will organise something - if you don't want to brave the massed throngs then you can go to one of their evening meals and dances - check out a ceilidh (Scottish dancing) if you can.
Great fun and helps mix everybody together.
So many things on around that time, MANY concerts ... alll around the city, gardens and in the castle - look at the website.
Edinburgh is a great city.
D.