Extend the summer of staycations and go local with these luxe offerings. Laura Hampson charts where to stay