The mod from that thread requires an old version of the Anno Domini mod to run properly, so you can't use it directly. But you can modify it (change the civs listed in the code, and replace the WorldBuilder map with yours), to create your own hotseat scenario. You can remove the dependency on Anno Domini using ModBuddy, or by text editing the .modinfo file in the "build" version. Also it's from the G&K era, so it's possible that there will be some problems when running it with BNW.
I don't know if there are newer mods that allow playing a scenario in hotseat, if anyone knows such a mod please let us know. Generally this area is an example of the "dark side" of Civ5 modding, where Firaxis needlessly complicated a thing that should be simple.