Three people have died after a fire at a historic building in a Northamptonshire village.