If you like loud music and shooters Senor Frogs is the place, cant beat the location right on the beach, if you want something else try the nightclubs next door, the bartenders let my wife play music and they were super friendly, I just dont know if i would venture off of 5 ave at night stay in the resort area and you should be ok.
I'm from Houston too.. and there is no danger that i know of? unless of course you go to the places where you would find yourself in danger, that is like going to 5th ward or 3rd ward in Houston. its ok to come down, I drove down here with my 10 y...