A cat been killed in North Yorkshire after being shot with an air rifle.