How can I disable the tweet sound when using Click to Tweet in Notification Center?
The "tweet sent" sound file is located at

/System/Library/SocialServices/Twitter.socialplugin/Contents/Resources/TwitterSent.caf


If you remove or change that file, then the sound should change accordingly.