An old industrial site could bring hope for locals by providing much needed housing as well as being an impressive visitor attraction.