The council says the land could be transformed in a major redevelopment