I used to have the Vega 64, now I have the Vega VII.
Regarding the fan noise, the Vega 64 duct fan is noisier and a lot less effective. The 64 got very hot, I do not recommend that card. The Vega VII is a lot better in terms of cooling and also a bit less noisy while having a lot more power than 64. At least it feels this way. To best describe the current fan noise, it is not super quiet as an iMac but it got better with the last OSX iterations. The question is how much of a low noise fan system do you need? The standard fans of the Mac Pro can be heard somewhat already. How much noise will be tolerable for you is relative, so assume you are in an audio-studio environment that demands low noise systems? My suspicion is also the MP PCIe Bay Boost fan that gives off some of the fan noise.
What might be interesting for you is the fact that I am currently in discussions with AlphaCool Support to check on a hydro cooling system upgrade for the Vega7. Unfortunately, they sell the system only with a 240mm radiator at the moment. I would need the 120mm to put it inside the tower by loosing one HDD bay. I can customize it, but if would be more expensive. If you are interested in something like that, let me know and I will keep you updated on this question and send more info on that.
www.hwconfig.com