"Off road tire" is a pretty meaningless term. There is a broad continuum branded as "off road" by the manufacturer. I've run everything from a BFG AT to a bias-ply IROK.
At one end, you have a so-called "all terrain" tire. These are just the slightest bit more aggressive than a pure street tire and will ride smooth and quiet. They will work just fine in mild off road settings. As the off roading gets more serious, their performance will drop off. Of course, the performance will be affected by other equipment, like lockers.
If you need more off road performance than an AT will provide, then forget about quiet. The more off road focused the tire, the louder it's going to get. At some point, you're going to need to either accept the noise, or buy a second set of wheels for street tires.