Welcome to the forum. I can't help you much with regards where to go for kayaking or fly fishing, but have seen people go for drum and cats with flyies by wading out in lockport. If you go behind the subway, there is a gravel road that leads down to the red where the floodway meet the main river body. Seen people wading there and fly fishing and that area is full of cats and drum.
Good luck in your search.