Responses from family can vary drastically. I have found that it is best to share the good news with everyone around the same time, starting with those you are closest to, and who matter the most. Once you share your new journey with someone it will most likely spread quickly. Some are able to keep it quiet, some want to gossip and share their concerns with others, and some are just too excited to hold it in.
You can also make the choice of how much information you want to share with everyone. You may decide to share a little, see how it is received and then decide to share more.
We have found the greatest support in family that we didn’t expect it from. I have heard this from many adoptive families. My advice would be, don’t have high expectations of how others will respond. In the end it comes down to the fact that this is what is right for your family, and you are most likely excited and a bit anxious about this new adventure. Not to say there won’t be excitement with some family members, I hope there will be many who support you wholeheartedly!
What an amazing journey you are about to embark on, I wish you the very best! Hope this helps in answering some of your questions.