Quote fromOne site to get mods is at d2mods.com
It is important to get information on the mod before you start to install. The most important information is what version of D2 it runs on. Most mods are designed for version 1.10. The other common one is 1.09 for the older mods or the ones that decided it was better to stay at 1.09.
You can get some of the information here on some of the mods at Diablo Wiki Take note that Zy-El will be making its new home there shortly.
There are quite a few different types of mods out there. Some are minor tweeks for the single player. Some are massive changes to the game. Quite often they will have screenshots of the mod and they may even of a youtube video for you to look at.
If any questions message me and I will be more than happy to answer your questions
Much thanks. I'll take a look and see what catches my interest.