What this mod does is the following:

By opening the .jar file located in the folder inside of the skyproc patchers folder, a patcher is generated that iterates through every NPC in the game other than the player. To each of these it adds all the perks, but each perk is conditioned in such a way that it only works for NPCs that specialize in the associated skill and have enough skill ranks. In this way a bandit mage will have different perks perhaps than a thalmor mage, and much different than a two-weapon rogue.

Simply put this patcher at the bottom of your load order and you should be good to go. If you have problems, you may want to look through the FAQ for PISA (Pluto's Enhanced Skyrim Experience) for help. I'll try to help if I can, but I'm not as knowledgeable about skyproc as Pluto is.

NPCs do not gain certain perks that would have made the game entirely too difficult. For example, they do not have any of the instant kill perks like Headsman, Disintegrate, etc. They also don't have Impact, because that perk is broken enough with one person using it. Imagin going against three mages that can all stun you constantly. Eeps.

Other than that, you should have a much enhanced tactical experience.

NOTE: If you really want to continue at high levels of play, it might be advisable to get a multiple companion mod. Companions (if you have a mod that makes them level up with you, something that is broken in vanilla skyrim) will gain perks as you level just the same as any other NPC, making them a much more interesting lot as well.

(If anyone has suggestions for my description, I'd appreciate it. Also, images would be nice.)