Both BeQuiet and Noctua have good fans, although I do prefer Noctua personally. I never disliked the color scheme of the Noctua fans and my cases are all closed up and don't have windows anyways, so I don't really care what they look like to begin with. The power supplies of BeQuiet are also very well made. I was surprised to find that some people never heard of BeQuiet over in the US at least a few years ago and suspected it to be some cheap Chinese brand but it's in fact a German company. (Noctua is an Austrian company btw.) BeQuiet had a problem with Chinese power supply counterfeits a while ago though.
The trick with Fans is and always will be to get the biggest fan possible. The bigger the fan is, the slower it can spin to transport the same amount of air. A 20 cm fan for example can transport a lot of air with an RPM in the low hundreds you'll be very pressed to hear even if holding your ear close if the fan is made well enough. Then it's a good idea to decouple the fans with rubber bolts that will optimally catch the vibration of the fan going into your case which causes the most noise with crappy fans. Noctua fans at least usually already have the rubber bolts included. That being said, good, proper working fans should not cause much vibration.
Then it's also a good idea to always get the somewhat more expensive PWM fans as long as your mainboard supports it (pretty much all do these days is my guess) as PWM fans are better to control in speed by the mainboard and are always supplied the same voltage. (Reduction of the speed of a PWM fan is reached by basically turning the motor on and off very quickly, this allows for very fine-grained control) Modern DC fans have become very, very good at running at low voltages but the PWM control method is in general smoother and more predictable, also not all Mainboards can control a fan by reducing voltage.
You can also gain a lot of quiet by creating noise profiles depending on the temperature in the case. Most modern computer firmware can do this. Many people put all their fans at full-tilt if temperatures go beyond 45C or so, but for such electronics, that's basically nothing. You can plan your limits with 60-80C in mind really, depending where. Ideally you want also a case that allows you to do good air cooling and install good fans. Not all cases are good. A case that can take the aforementioned 20cm fan is always preferable. In normal operation (non-gaming desktop stuff or light gaming) with a good CPU heatsink on an average 65W TDP CPU you should ideally be able to turn off some of your case fans completely and it's perfectly possible these days to have a computer that's completely inaudible in that operating mode and only gets somewhat louder with heavy gaming if you pick the right fans, heatsink and case.
