Council approves ‘no shot, no leave’