Straw Pipe is an item found in Red Dead Revolver.
As with all similar items, the Straw Pipe is not used in the game beyond unlocking a showdown character and journal page.
The Straw Pipe can be purchased from the Shop interface at the start of the mission "Fort Diego". If not purchased, it is not subsequently available during the current game.
Forum posts
YouTube videos Rockstar site