A new report has warned of a "clear decline in trust" in the Scottish government since devolution, with less than half of respondents saying it acts in the country's best interests.