What type of housing would be ideal for you?

Depends on what you are doing

no housing if you are making circuit changes (bread board)

clear and waterproof if you send a camera down a pipe

Finished wood to match furniture for your living room

metal if you dont want rf in or out