The suspect in the bizarre daylight execution of a prominent Houston doctor killed himself as police confronted him, chief says