Should I tell him about my one-night stand?

It can go either way because we can’t always predict how people will react. The only thing you can do is be honest, if you choose to talk about it, and hope he sees it the same way