the Navy will relocate your family to wherever it is you are stationed, provided that you will be there for longer than 6 months. This means that you go to boot camp in Great Lakes, solo, for the 2 1/2 months. Then they ship all of you to Goose Creek, SC, where you can live in base housing (highly recommended) while you attend Nuclear Field "A" School (duration depends on your rate) and then Nuclear Power School for 6 months.
After Power School, you either stay in Goose Creek for 6 months for prototype training or the Navy ships all of you to Ballston Spa, NY, for 6 months of prototype. There is the possibility of 3 months of additional training at either site if you are an MM and are selected for ELT.
After prototype, the Navy sends you to whichever carrier needs you. There is a period during prototype where you get to put down where you would "like" to go (ship, home port wise), but in the end, the needs of the Navy will dictate where you end up (you're going to see and hear that phrase a LOT).
Since you're a female sailor, you'll be assigned to a carrier (yes, women are now being assigned to a few select subs, possibilities are low and on a volunteer basis). So, your choices will be Norfolk, VA, San Diego, CA, Bremerton, WA or Yokuska, Japan. You can request Navy housing, not a guarantee. Otherwise you get an allowance to cover living out in town; it almost always doesn't cover the entire cost. Then you'll report to your carrier, you'll get underway for the first time and your husband will become a single parent. This will go on for periods of a single week up to deployments of 6 - 9 months. Your first sea assignment is for a minimum of 36 months.
Not trying to scare you with the "single parent" statement, but's that a simple fact. you'll be able to email him, usually, but you wont be talking to him for the duration of your time underway. He will have to take care of everything while you are gone, and depending on how your current relationship is setup, that works out OK for some couples, not so much for others.
Other guys/gals on here will chime in with other info. Best of luck and remember that if you join, you do so voluntarily. Everything after that, good and bad, you have to roll with it and make the most out of it.