yip as said im sure yous will have a brilliant time.if you aint got tickets for the street party yet you can get them now online
http://www.edinburghshogmanay.org/
worth buying tickets for that then even head of to a club afterwards.but again some places will be ticket only i think.