From Belgian castles to British estates, these decadent structures show how, even in decay, they still hold a certain allure