Rosmerta is in Hogsmeade if she ever goes to the Three Broomsticks for drinks or anything. She'd definitely be friendly. Ros likes Hogwart's staff members.
Then I've got Sybill Trelawney, who is probably not the best at Herbology, but I'm betting she tries! She's probably not the worst either.