Depends on the fan itself. So, model of the NZXT fan is?
Some 3-pin fans are quiet, while others are not. But when you connect it to MoBo fan header, you can often set custom fan profile for it. Or you can use fan controller and adjust the fan speed yourself, manually.
Also, do note that you can not get two at once: quiet operation and high airflow. It is always either: quiet operation and poor airflow OR loud operation and good airflow.