You can set an alarm tone using any song you have within your iPad music library. To do so, set up an alarm as usual. In the box, tap the row that says “Sound”.
Under the “Songs” category, select the song on your iPad that you want to use as the alarm tone.
Have fun with your iPad!