A former church hall will be sold after the council decided it no longer needed the building.