To unlock the A Household Name trophy in DiRT Rally 2.0 you simply have to finish a Custom Championship.
Head over to Custom Event and create a new Championship with one event and one stage.
Finish the stage and once the post-event results screens have been displayed, the trophy will unlock.