Look here (on Windows):
Documents \ My Games \ Sid Meier's Civilization Beyond Earth \ MODS
And you might also just "Subscribe" to a mod on the Steam Workshop.
Either way, choose "Mods" when starting the game, after the mod's been subscribed or unzipped to that folder.