Why you don't try at any city of Canada. These all have quite cool environment and well equipped places to visit like you have never seen before. Currently I am in Fort Mcmurray and it is my personal experience towards the climate and surroundings.
Moderator comment: please see Forum Rules
[ Edit: Link to Forum Rules added. ]
Scotland - but avoid Edinburgh and Glasgow. Overpriced and full of lager louts.
Get to a small country inn and soak up the 'real' Scottish feel for NYE. The country folk are experts at it.
Glasgow and Edinburgh are OK if you want to slip and slide through piles of sick and endless kebab wrappers. Otherwise - get to the mountains and see how it's done properly.