Hi Post
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.
Hope this helps
R21