No, it is not downloaded. It runs off of the server. All of the content (tiles, monster graphics, etc) are already installed on the client machine. That is why if you use custom tilesets or other custom content, the client must have it installed or won't be able to play the module. NWN does not support autodownloading.