Some children and adolescents seeking mental health treatment are not getting appointments for up to two years, a new report has found.