Clay is a really good retainer for water. Having a nice layer of it covered with gravel throughout would make a great pond base. For retaining 6’ wall at one end using clay I would give it a go personally. Just make sure it’s plenty wide. Would really be nice if you could get some boulders in...