The £50m art bonanza has funded everything from Gormley's Angel of the North to a 48km sculpture trail