After nearly eight years, a local football team has secured a lease to transform a derelict site into a “vibrant community hub”.