If i sign out of the find my iphone app will the sound still go off?
Short answer: Yes.

Long answer: The app is an interface for the FindMyiPhone service. This service is controlled in the iCloud menu of settings. So unless you disable Find My iPhone in the phone's settings, the sound will play.