I have to chime in on this one. Hofbrau is great, depending on when you show up. Its the only place I know of where you can drink liters of beer while enjoying a summer evening. All the beers are pretty good. Just dont go if its friday or saturday night. When the preppie bars downtown closed, hofbrau became the new hangout for the country club set. It gets WAY too crowded, and 2 of every 3 people dress like theyre auditioning for those new god-awful hilfiger ads. Then again, maybe thats your thing. If hipsters piss you off, avoid the northside tavern. The Comet would be my recommendation. Its really a bar with a large dining room and a stage. Pretty good selection of bottles; on tap its more pedestrian. Theres usually a live band, and rarely does the live band suck. The food is pretty good too. Parking sucks, but no place is perfect.
Other suggestions starting in newport and heading north:
The previously mentioned Beer Sellar
The Rookwood Pub / A chain place, but a good one. Try the burbon cask ale. Im the only person I know who hates it
Brazenhead Irish Pub / Add the beer sellar's selection to the rookwood pub and move the whole thing way out to the northern fringe of suburbia