Yes, Fan itself is working fine if plugged to CHA_FAN and there is no high pitch sound. It is only when connected to CPU_FAN the problem persist.
BIOS detected the fan RPM as usual when its connected to CHA_FAN or CPU_FAN its just that i cant get rid of the sound when connected to CPU_FAN.
I dont think the problem is with fan itself, i have also changed my PSU without any luck. For a temporary fix, i converted the 4 color PWM fan to standard 3 color fan pin and control it manually via my speed fan knob.