Can I add a table in a custom module?

Yes!

Droptables is built to be used in every WYSIYG editor field, you just need to have content plugin to be called. Most of the time it's activated by default.
It's not the case in the Joomla HTML custom module, you need to activate it.

In the option tab you need to set the option Prepare content to Yes.