Many pieces on show in the Spanish Gallery are from the personal collection of financier Jonathan Ruffer, the main backer of a £150m regeneration project in Bishop Auckland