The newly opened private quarters of one of Britain’s most original architects reveal morbid passions alongside the marvels