A top female politician in the northern Spanish city of Leon has been shot dead in public.