Fewer children in Scotland are smoking, drinking and using drugs, according to a new report