Subscribe to download
Roggvir Savable and Recruitable

[NOTE] There are issues with this mod that I've not been able to solve. I have a suspicion it has to do with a change Bethesda made during a patch (or maybe not, I could be wrong). Either way, as a number of people have noted, Roggvir no longer has appropriate dialog--or he dies anyway--or the entire town remains hostile, making it impossible to save him. I may actually remove this mod altogether, since it no longer works as promised.

INTRO...
Frustrated by the way Roggvir is killed by script, even though you worked so diligently to save him from the chopping block? Well, be frustrated no longer, friend! With a few changes to the Solitude Opening quest, you now have a chance to actually save his life. If you're successful, he'll be quite willing to become a loyal follower, and possibly more.

SAVING HIM FROM THE CHOPPING BLOCK
This really shouldn't be attempted unless you have a strong sneak skill. Magic is probably not a good idea here... noise will cause lots of problems. You really need to be able to take out the targets with one shot. Otherwise, you just piss everyone off & end up very dead, very quickly. Likewise, Captain Aldis, the guard to his left, and the headsman will all immediately gun for Roggvir. Him being defenceless at this point, he doesn't stand much of a chance.

Take out the guard at the top of the stairs first. Stealth kills here, again, like I said. Then Captain Aldis. By this point, the headsman will realize something's wrong, but Roggvir now has a chance to survive. Take out the headsman, and from that point, everyone else will just wander around a bit, confused. Even with the primary players dead (save for Roggvir, the point of the exercise, no?), the crowd still stands around, since everything's runnng on a timer.

Roggvir will move back to the headsman's block and stand there, still bound. Wait until he starts to walk away and eveyrone begins to move back into their default routine. That's the cue that the quest has finished, and this is when you can talk to Roggvir. He'll have one option available: Follow. That's it, that's all.

Pay off any bounty you might have gained during the commission of this escapade, and you're off to the races. I suggest kitting him out in something more appropriate than the prison garb he's in, but that's up to you. From this point on, he's essential, and scales to the player. He has no alliances to the city of Solitude (crime faction, town faction, etc), so no worries about committing crimes in Haafingar and him getting in a twist about it.

CAVEATS
Also, as a few people have pointed out on the Nexus, killing the Captain and the headsman will most certainly break several quests, and the quest involving Roggvir's sister is no longer possible (I stop the quest if Roggvir is still alive at the end of the Execution scene).

AS A FOLLOWER
Since he was a city guard, I've modified his actor to carry similar stats as one. I changed his class to CWSoldier class, rather than 1HWarrior, since he will switch between 1H/2H/Bows where appropriate. He is brave, and will attack threats to the player. He will commit violence against enemies as well as lesser, naughty things if asked to, but will not attack innocent people.

AS A SPOUSE
Want something more than just a follower? Equip an Amulet of Mara (See the priest in the Temple of Mara in Riften and speak to him about marriage), and talk to him. He's in the PotentialMarriage faction, so it's just a matter of arranging the wedding with Maramal. Don't be late!

STEWARD CANDIDATE (HEARTHFIRE REQUIRED)
If you have the Hearthfire Expansion, he can also be asked to become a steward at your residence. You have to be at the house in order to do so. Just speak to him, and the option should be there.