A single-band antenna will almost always outperform a multiband antenna. Whether that improved performance makes a noticeable difference in your application is difficult to say.
The low profile antennas for 800MHz work pretty well and provide gain over a standard quarterwave antenna. They're pretty close in performance to 3dB gain "curly-cue" whip antennas that were popular for a long time, which are about 7-8" tall. There are also higher gain 5/8th wave antennas which are taller.
If you've programmed your scanner to "roam" automatically among VIPER sites as your location changes, then you may not find that the single-band, higher gain antenna makes much difference. There are lot of VIPER sites and they're pretty close together, so you're not likely to be out of range of a VIPER site in many places. As noted in previous comments, gain to the horizon (which translates to better reception at longer distance) comes at the expense of performance above the horizon. If you find yourself "under" a tower, you might notice more trouble with reception, but that's usually only an issue if you're really close, say within half a mile of the tower.
On the other hand, if you're wanting to monitor a specific site (or system) outside its intended coverage area because that site or system carries specific talkgroups of interest that aren't carried on the closest sites, then increased gain might help. In Asheville, I would guess that simulcast (on the Buncombe Co and Asheville systems) is a problem for your scanner that won't be helped by antenna choice. Mountainous terrain obstructions (having rock between you and your monitoring target) is probably another. Interference from commercial data towers overloading the receiver on your scanner is probably another. A higher gain antenna might help in some of these situations, or it may make the reception problem worse. Trial and error is the best approach here. Fortunately these antennas aren't crazy expensive, and if you have an NMO mount, you can try different antennas to see which work best. Good luck.