Residents in a Leeds suburb have expressed their horror after two cats were shot with an air rifle, with one of them dying.