There is already steam work shop which is steam's mod page built into thr game so you can effortlessly install mods.
if you really want to mod skyrim extensively, you will need nexus mod manager and the nexus mod site which houses far more mods than what steam has. But this requires bit more work and research to use as skyrim isint the most stable of games.