Unfortunately, only mods that contain meshes and textures are allowed.
Everything else like triggers, lights and scripts etc. will be excluded from the mod once the mod is uploaded to the workshop. It may be possible to use script mods locally, but there is no manual or other documentation about it. :/
Long story short, I don't think it's possible.

More of a developer question I think. The mods, are the things you find on the Workshop tab. The people who do the mods are limited to what they can or can not do (ie, they can make lights, but not ones that turn on, they can make doors, but they don't open or close, you can just walk through them though). They make amazing stuff in the Workshop, but are not coding the game itself.