A number of New Year celebrations were disrupted by stormy weather, with many fireworks displays called off across the UK and the Edinburgh Hogmanay street party cancelled.