Stop Macbook from making sound when plugged in to charge
I was not able to check it myself, but I found that link here: https://www.iphonetopics.com/enable-power-charging-indicator-sound-mac/
It seems a app called PowerChime can do your need.