Right so this is the kind of thing I find genuinely interesting from an earth mysteries angle - a lot of people jump straight to "ghost" or "animal on the roof" but there's a middle ground that doesn't get discussed enough.
Dogs are particularly sensitive to infrasound, frequencies well below human hearing that can be produced by geological activity, underground water movement, even certain atmospheric conditions. The staring at the ceiling behaviour is classic - they're tracking something we simply can't perceive directly.
The roof sounds combined with the dog's reaction could point toward a convergence of phenomena rather than one single cause. I've had similar nights out in the Nottinghamshire countryside where my old lurcher would just lock onto a fixed point and nothing I did would break his attention.
What was the weather like? Any storms in the preceding days or significant temperature drops? Also worth noting whether you're near any limestone geology or old mine workings, both of which can produce unusual acoustic effects. Would love to know more details before anyone jumps to conclusions either way.