As a [British] NES, the difference, to me would be that "at somebody's house" would be the generic term I would use to cover both inside the house itself or chatting to them in their garden, for example, whereas "ïn sombody's house" would mean physically inside the actual building itself.
If you have a question about the English language and would like to ask one of our many English teachers and language experts, please click the button below to let us know: