Yes, the sound for the alert is sent to serverski side.
Apple documentation on this issue (table 9-1)
Speaking about the implementation itself, in principle, should not be a problem, because all custom sounds can be saved in the project. And when the user changes the sound, the application sends the server a request with new settings for notifications.