The actress owned the 400-year-old estate for decades, renting it out to a series of rock bands for recording, including Radiohead and the Cure