Three people have died after a crash involving two cars in Northumberland.