Welcome to Tom's Hardware Forums,
The stock Intel heatsink fan will be fine. As long as you have adequate ventilation in your case, the only concern I might have is if you run extensive gaming sessions with turbo enabled, you may want to monitor your temps. Other than that, no worries.
Hope it helps
If the stock HSF was not good enough, Intel would not be shipping it with boxed CPUs as the official heatsink for full warranty coverage.
However, everyone I know who has had a LGA775/1156 motherboard and used the stock HSF ended up having thermal problems after ~3 years likely due to the plastic frame + push pin setup loosening from deformation (thermal + vibrations) over time.
The above is just a little something to keep in mind if you start noticing that your PC is becoming sluggish for no apparent reason ~3 years from now, it may very well be thermal throttling telling you the stock HSF needs replacement.
Managing to design a HSF mounting mechanism that seems to fail so predictably is a small feat of engineering in itself.