Edinburgh's Hogmanay events have been cancelled and football matches will be effectively spectator-free as part of tough new Covid rules in Scotland.