Every time I put a CD into my MacBook Pro or eject a disc from it, it makes a noise like as if it is spoilt. Is there a way to change this noise?
The noise you describe is completely normal. Every slot-in drive makes some noise as it pulls in or ejects the disk.
You should also hear some noise from the drive when you start your MacBook or wake it from sleep. This is absolutely normal too.
And no, you can't change that noise.
From Apple Support (emphasis mine):
Here are some sample sounds that show you what the drive can sound like (AIFF files).