Email notification can be achieved using workflows or process builder on record update.
For attachments being added to a ticket, custom apex trigger or a scheduled job will have to be written on Attachment object.
- an attachment record is inserted
- the parent ticket to that attachment is identified as (one of the queues you want extra notification)
Then send out a email from Apex including the attachment to the queue owner or a email DL.