You will earn this through normal story progression.
Once you have completed the quest, "Urn of Sacred Ashes", you will need to return to Red Cliff Castle and give the ashes to Arl and you will revive him.
Once you are done talking with him you will have earned the "Hero of Redcliffe" achievement. You will also earn the champion specialization for your characters should you accept the Arl's reward.