You can adjust the alpha value of the sprite's self_modulate
property. So, something like this:
$Sprite.self_modulate.a = 0.5
The above will set the alpha value to 50%. To animate the change, you can drive that value via a Tween
or an AnimationPlayer
....