From saints to selfies: Great North Art Show 2014 unveils a fascinating new portrait exhibition