For what I could find, "familia de acogida" is similar to a "foster family": a child goes into a foster family so it will grow up in a family environment when its biological family can't take care of it.
"Familia adoptiva" is used when the child has been legally adopted.