Your first option should be to confront your brother-in-law. It is possible that the affair is at a very initial stage and he will see reason and break it off.
If that initiative is successful, your sister need not know about it for now.