Something this important shouldn't be played by ear. Do some research on the topic (exposure, and what to tell kids about infidelity and potential divorce) on BOTH sides; maybe seek the advice of a couple of close people whom you trust and respect. And then do what feels right and authentic to you.
Me, I ultimately decided if I was going to err, it was going to be on the side of ALWAYS TELLING MY KIDS THE TRUTH.