I think the best sedimentary indications of the lake are at Bannockburn but the fossil remains are not really very spectacular though one day someone will find something there and reptilian remains etc have already been found in the form of crocodile bone and tooth.
A lot of diverse fossils including extinct bird, fish and small seeds from trees etc.
Lake Manuherikia is a very fascinating subject in its entirety & a very complex geological event that today you would be very hard pressed to know that is ever existed when driving through Central Otago.
Here are a couple of links you may find interesting.
Agree the Aronui channel (Late Pleistocene) and Fruitlands Flat channel (middle Pleistocene).
The little object was found at the mid creek section on Butcher creek, on top of the Miocene sediments.
I found two of these some years ago while panning of all things. They are quite light and look for all the world like little flattened button mushrooms. Always wondered what they were! About 15 to 20mm across.