Depending on your version (Steam vs. Non-Steam), different mods work best:
While there are many legacy options, these are the most reliable for modern systems: ZBot (ReGameDLL_CS): Counter Strike 1.6 With Bots All Maps Onlin...