A former chief constable who had affairs with two subordinate officers showed "persistent dishonesty and lack of integrity", a tribunal found.