Since all comments seem to agree that noise cancelling wont work, 3 practical tips:
1. use the Bernoulli-Effect, aka get "up to 50+%"(depends on fan model) more airflow by placing the fan 0.2(0.5) - 1.5m away from the window.
2. Blow air out of the window, dont try to suck air in.
3. To avoid noise: Put the fan in another room and open the window in the room where you are.