The Hubble Deep Field-North SCUBA Super-map - IV. Characterizing submillimetre galaxies using deep Spitzer imaging