How much public access does their have to be to make a public asset really benefit an entire surrounding community?

Even a small area to launch a  SUP or kayak matters, right?