The street party and fireworks display over Edinburgh Castle were cancelled on Monday afternoon due to a Met Office yellow weather warning which covers most of Scotland throughout Hogmanay.