You should realize that the fans on your radiator are SUPPOSED to change their speeds as your workload changes. Also realize that forcing them to run slow means you are NOT getting the cooling of your CPU chip that it needs at higher workloads.
That said, I realize that some fans are noisier than others for similar air flow. And it really is air FLOW that is required. But especially on a radiator, the ability to deliver that flow against a higher backpressure (air flow restriction by narrow air passages) is important, so you need to look also at the max backpressure spec for any fan you consider.
IF you have your radiator fans connected (via the small Splitter unit supplied by Deepcool) to the CPU_FAN header, then that header is how those fans are controlled. Remember that fan speed, noise and air flow (thus cooling) all go together. The normal automatic fan control system used by the CPU_FAN header actually is a TEMPERATURE control system. That is, it has a temperature target to meet as measured by a sensor built into the CPU chip itself. It will change the fan speed to whatever it takes to keep that internal temperature on target. The fan speed is the manipulated variable, not the ultimate target. Normally the CPU_FAN header can ONLY use that internal sensor to guide it, but IF you have those fans plugged into a different header, then check its configuration settings. Some fan headers allow you to specify which temperature sensor the header is using, and a different sensor on the motherboard is always an option. IF your rad fans are connected this way, make sure their header is configured to use the sensor inside the CPU chip.
Most mobo fan headers also have an option beyond the "normal" automatic one. This is often called "Manual" or "Custom". It allows you to specify a different "fan curve" from the pre-programmed one. That is, there's a graph of what speed the fan should run for each temperature in the operating range, and usually you can specify four or five points along the curve. This can be used in two ways. One is to make your own curve and force the fan to run slower and quieter than "normal" at all times, BUT that means you are also forcing your CPU to run hot all the time. The other is more subtle and may be useful to you. Often a fan is running just on the edge of switching from one speed to another, and almost any change in workload causes the fan speed to jump. You can set your own curve to change the temperature at which the fan speed jumps so that it happens less frequently and is less annoying. To do that you do not need to make the fan stay too slow at very high temperatures.
With that background that applies no matter what fans you have, back to your plan. I think you are a bit confused on a couple of points. First, most fans do NOT stop at low temperatures and workloads. Automatic fan speed control systems deliberately avoid that by never sending the fan signals to run so slow that they stall - they always run at a minimum speed, or faster when needed. That is, unless you configure the fan control system to defeat this. Now, for users who are not using mobo automatic fan control systems, Arctic does supply a line of CASE VENTILATION fans that DO have their own temperature sensors built in and CAN stop at low temps. For example, their F12 TC model has this feature - note the "TC" suffix in the name. But that is NOT the fan you specified.
Secondly, you do NOT want a fan designed for general case ventilation, because they are designed for max air flow against very little backpressure. See this page from Arctic
With the P-Series and F-Series fans, ARCTIC has fans for both high static pressure and high airflow. Which fan is best for me?
www.arctic.ac
Your plan was to buy an "F" series fan optimized for max air flow against low backpressure. For use on a radiator, you want fans from the Arctic P series like this
https://www.arctic.ac/worldwide_en/p12-pwm.html