A top councillor in Northumberland has said he remains hopeful a transformative “gigafactory” can be attracted to the county despite the failed Britishvolt saga.