You could also say:
What kind of museum did you go to yesterday?
The main thing which makes your original question sound awkward is the preposition at the beginning. In spite of what traditional grammar books might say about 'correct' sentence structure, we frequently end sentences with prepositions and almost never start sentences with one.