Pubs, gyms and non-essential shops will reopen for the first time in months after Nicola Sturgeon announced a major lockdown rule change in her Covid update.