After 1,000 years, the fortified stronghold of Durham’s mighty bishops is finally opening to visitors. Our writer scales its siege tower – and marvels at the prospect of a 13-orb glasshouse