“We must now look at what services we have to cut,” says North Yorkshire council leader