Improve cleanup of tables and types in CQL unit tests

Patch by Benjamin Lerer; reviewed by Tyler Hobbs for CASSANDRA-8427