Rename, split and merge cppsuite class files

The scope of this ticket is as follows:

• Rename cppsuite class files to reflect their intent and be more cohesive.
• Ensure each class definition is in its own file.
• Merge classes where it makes sense to do so, such as scoped_connection & connection_manager.