The former Lord Lieutenant of County Durham, family brewery head Sir Paul Nicholson, has died at the age of 86.