Acute hospital wards are facing "real challenges", as a study showed the number of children being admitted due to mental health concerns has gone up by two-thirds in 10 years.