Locals had long shared stories of Collyweston Palace. Then, excavations in England’s Midlands revealed traces of the fabled estate