Edinburgh on Hogmanay night isn't something I would choose to do - too much drunkenness.
Though I should be down your direction on New Year's Day, weather permitting, I will probably go to Stanhope for Ne'erday lunch as I have done the past two years.