You can get case fans that are very quiet but only spin at one speed. Obviously you can't ramp up further as things overheat but for many people that's quite sufficient.
1000RPM or below is generally very quiet though it depends on the fan quality.
You can find 4-pin (PWM) or 3-pin (Voltage) controlled fans for as little as $12 through PCpartpicker or wherever that are pretty good. Then attach them to the motherboard so the fan control software can spin them.
Note most fan control software won't go below 40% of the fans max specs which means if the fan was say 600RPM to 2000RPM (variable) the lowest you'll go is 800RPM. That's not too bad but if your fan could go up to 3000RPM then the fan is going to start getting noisy even at its...