Congratulations Georgiegirl, such a wonderful world is opening up for you! When I had my first baby it was lovely having visitors, friends and family, neighbours and so on, who popped in with cards and gifts. They would want a cuddle with the baby, even if I'd just settled him after a feed. I loved all this of course, proudly showing him off, but it was exhausting and impossible to establish any sort of routine. I longed for the evenings, when there would be no more visitors, and my DH was home from work to help and support me (no paternity leave in those days!)
The thought of having even close family actually staying with us at that time would probably have reduced me to tears, so I do understand your DiL asking that you stay in a hotel when you visit. And as Alea said, you will at least get a good night's sleep!
Enjoy your new GC - 200 miles isn't so daunting a distance these days, so you should be able to visit regularly. And there is always Skype!