The off-duty officer, a member of the department’s special response team, said he would kill himself and fired shots into the air before shooting both responding officers