We have stayed at Sugar Mill, which is nice, however our preferred spot to stay is at Surfsong, which is on Beef Island, right by the airport. I just checked their website, and they may not be open, so you would have to check with them first. There's no issues with aircraft landing etc - flights are pretty infrequent.