Appeal made to new First Minister as shock survey lays bare dire levels of business confidence in Scotland’s £1bn self-catering industry