A weather warning of heavy rain has been upgraded to amber for part of northern Scotland on Hogmanay, as the street party and fireworks at Edinburgh’s New Year’s Eve celebrations were cancelled.