Welsh mayor not seeking re-election