If you're looking for inspiration, see
@AtmosTotnes and their campaign for a community-led development (hotel, training resource, facilities for young people, retirement homes, a microbrewery and much more) of a brownfield site. All led by, and for the benefit of local people.