The famous house in southeastern New York state was once used by The Band. Now it's available to the public for overnight stays