Weather balloons appear as small objects in the night sky, resembling bright dots. They are usually equipped with flashing lights to make them more visible. These lights help track the balloon's location and movements. Overall, weather balloons provide an intriguing sight when observed during nighttime stargazing.