The rocket was designed and built in Houston. Houston is what type of noun?

"Houston" is a proper noun. It specifically refers to the name of a city, distinguishing it from common nouns that refer to general items or concepts. Proper nouns are always capitalized, indicating their unique identity.