The Waterfront is usually popular. Out of the train station turn right and down the canal on the right hand side.
Other than that as the above said Stratford Haven in West Bridgford is good but a good 30 minute walk from the station.
Hooters? Overrated and overpriced.