Mod developer Axarien has released a new mod for overhauling over 125 NPCs included in The Elder Scrolls V: Skyrim. As Axarien points out, this mode has reworked 125 male and female NPCs and improved their appearance.
The mode usually changes the NPCs of the main game. However, it also includes a few of the Hearthfire, Dawnguard, and Dragonborn DLCs/expansions.
You can download the mod here
Note that this mode is for Skyrim Special Edition, not for the Original/Old Version. Below you can also find screenshots showing some of the reworked NPCs.
Screenshots