The Child and Family Agency has apologised for what it says were unacceptable shortcomings in the care of a teenager who spent much of his life in state care before dying of a drug overdose.