National Football Museum’s future secured after new lease and funding agreed