A weather warning for severe rain could put a dampener on Edinburgh’s Hogmanay celebrations as Scots are being urged to prepare for ‘significant disruption’.