A giant radio halo in the low luminosity X-ray cluster Abell 523