Pubs and restaurants in Scotland are said to be taking a hit in business as a result of the boom in weight-loss drugs, a new report found.