A massive Victorian—“the epitome of crumbling magnificence”—was both home and studio for the “Space Oddity” singer in the late ’60s and early ’70s