The leader of Southampton City Council has said more people need to be able to access Southampton's waterfront