no you get a Br- ion... and yes, it just hangs around in aqueous solution.
If you were to electrolyse the solution maybe some bromine could be formed provided: 1. you keep the temperature high enough (bromine is a liquid at RT and it will redissolve in the water making bromine solution) 2. The solution of bromide ions is sufficiently strong otherwise all you will get at the anode is hydrogen.