Honestly, no.
Skyrim is designed for the single player experience, and it barely manages to pose a challenge/hold my interest with that.
What would need to happen to have multiplayer be even viable would be:
-Better enemy AI coupled with.
-More tactical combat.
-Everything is stronger.
-Bugs get fixed
-A slight story change to accommodate for possibly more than one Dovahkiin.
-A good loot system for deciding who gets what
-Something engaging other than each other's shenanigans.
Now, the first two points are big ones.
The AI ATM is terrible, and the combat is button mash. I am sorry, but this doesn't work in multiplayer. The game has to pose a challenge, or have some kinda of interesting thing, to grasp the attention of both players beyond their simple shenanigans, else it quickly becomes monotonous (A problem Skyrim has anyway). Combat more akin to Dark Souls, and more interesting spells, some better Archery abilities - this sort of stuff coupled with an AI that knew how to use them, that would pose a challenge adequate for 2 people, as opposed to the usual big meatbag 'challenge'.
Making enemies stronger would also help.
There are enough bugs in vanilla Skyrim to f*** up a whole game, imagine the ones that would happen in multi. Now, if all bugs in vanilla were fixed so that multi bugs could be quickly isolated and dealt with, then that would be ok.
The story is of one Dovahkiin. Slight changes of lines and basic story would allow for multiplayer through story too
A good loot system is required, otherwise players just fight over who gets what and it is no fun.
Currently Skyrim is one big monotonous world, with little to hold my interest. Disagree if you will, but the game is pretty much a hiking sim. Things that could grab my interest would be good combat - sadly there is none - some reasonable dialogue and in depth characters - there are a rare few in the world that fit this description - more interesting quests - there are maybe three or four that don't follow the 'Go to location, kill stuff, come back' formula - More varied areas - How many times can you walk into the same crypt with the same challenges and not sigh at the fact another monotonous 'adventure' is upon you, there were few areas by the end of the game that I had not seen duplicated 10 times - more interesting and varied challenges - those stupid stone puzzles got old real fast, that one in the tomb of Jurgen Windcaller was a welcome refreshment. There are probably more, but this list has gone on long enough.