Go to Settings > Messages, where you can:
Manage notifications for messages. See the Basics section -> Alerts and Notifications Center.
Set the alert sound for incoming text messages. See the Basics section -> Sounds and silence.