An exhibition showing the largest public collection of LS Lowry's work, entitled A City's Pride, goes on show in his home city of Salford.