Depends on if the card has the feature. You can see it in the Radeon software under Performance > Tuning > Custom > Zero RPM.
You can also tweak the fan speed there.
I think some higher end AIB partner made cards have the feature. I have a Gigabyte Aorus 5700XT and it has the feature.
On the desktop the fans will occasionally spin up a little if the feature is on, but most of the time they'll probably be off especially if you have good airflow otherwise. In gaming or other loads on the GPU the temperatures will rise and the fans start.
[ 5800X3D | XFX 6950XT | MSI B550 | 420mm AIO | G.SKILL 32GB 3600Mhz | 1000W Platinum | G9 240Hz | Moza racing gear ]