Married Texas police chief accused of cheating resigns after arrest