While still allowing notifications for Gmail in general at the URL opera://settings/content/notifications?
If so, I think you'd have to do that in settings in Windows. Under System -> Notifications, you'd have to click on Opera and turn off sounds for Opera's notifications.