'World-class' cultural visitor experience to open in Northum