Looking for a Kayak but am not sure which model to go with.

New to Kayaking and looking for a tandem kayak to be used on lakes / rivers and possible inter coastal, recreational use and fishing
Not sure which way to go. Solo won’t work. Need either a Tandem Kayak or go with Canoe (not a huge fan of canoes)

Need multipurpose for the family but preferably fishing when possible. Can go with recreational model but outfit it if possible – not just add a rod holder. Want it to still look cool.

Will use on lakes – small river and possible inter coastal in South Carolina.

Any help is greatly appreciated. Budget conscious so please no .. Hobie responses. I would love to get one if I could. I can’t.

Has anyone hear of Crescent Kayaks? If so, am looking for real reviews.
Thank you