The Texas high school principal shot himself in the head last week after school officials confronted him about the alleged affair