A large-scale litter picking project to tidy up beaches and rivers across north Wales has been hailed a success.