North Yorkshire has the highest rate of people believing the local police does "an excellent or good job" in England and Wales, a new survey suggests.