An extensive exercise involving some of the smallest vessels in the Royal Navy fleet has been hailed a major success.