The curious but compelling building will house artefacts such as a 12th-century Bible and Mary Queen of Scots' death warrant