You need to set the MoH on the inbound ports to CUAC and then change the CUAC system to answer the call. This will have the CAUC server answer the call then place it on hold. This will play the music assigned to the port for caller in queue. It is probably easiest to make custom audio with the announcement followed by the hold and then upload that as the hold audio.
Page 8-35 here talks about the queue arrival mode and using MoH - https://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cucmac/cuaca/12_0_4/admin_guide/CUACA_AG_120402.pdf
See pages 1-11 and 8-20 for more details on the MoH config needed to make this happen.
Please rate if this is a help and have a great day!