Not sure if it sells real ale, but I've spent a few blurry evenings in the George Hotel in Amesbury! I think there's another pub called the Greyhound (???) too, but only ever went in there once. They are the only pubs I can recall.... Amesbury isn't a big place.