A prominent waterside site in Bideford, which has planning permission for new homes, commercial space, a marina and car parking, has gone on the market.