Museum of Making transforms ‘sleeping giant’ into trailblazing heritage attraction