A report warned there is a relatively high level of drug use among young people in Scotland compared to the rest of the UK.