People in Scotland will be able to return to beer gardens and pavement cafes as they open for the first time in 15 weeks.