I got it with a character years and years ago that was neither a lord or a council member. Guess again!
OK, I will.
Now that I know I have already received the fame points for a "Legendary Hero" I will offer another, more educated guess.
A "Legendary Hero" is one who fights alone (only his unit) against a superior foe and dies in the battle.