it will give you a new mount, flaming horse
see walkthrough for location of the skull:
Skyrim Dawnguard Soul Cairn Horse Skull Quest Walkthrough