What a lovely idea!
I would think late 2nd trimester or early 3rd trimester would be the most comfortable time to go.
Some where close-ish would be good , maybe a nice B&B??
I would go but Im not good at staying over night away from my DD and DH - just a personal issue I have! But it sounds lovely!!