A former nightclub should be redeveloped by the council as temporary accommodation for the homeless, it has been suggested.