I'll "endorse" both The Blackwater Inn and Stumpknockers. The only problem with either of them is the distance from TV. Both have a great atmosphere and great food, too!
I cannot comment on Pisces Rising because I've not been there, but it does carry a superior reputation!
SWR