The north of Glasgow is perhaps the least discussed and least visited part of the city. Charlie Ellis takes a walk and a new look