I’m sorry for my late to answer you. I had some problems this last days and it was not possible to visit the forum.
1-Do you want the player/user to see the whole mesh?
Yes, this was my main idea.
2-Do you want the player/user to see only a part of the mesh?
This was my secondary idea (a desperate idea). I was thinking to hide the seam underground. But i prefer do not that if is possible.
3.-Should you use a seamless texture?
I thing so. But unfortunately i tryed using severals methods i saw in tutorals and none works for me. Also i tried to looking for a method into the official documentation and i found nothing by the moment.
4-Can you use a texture that covers the seam (e.g. wood)?
That Is not the idea, i would like to use a dynamic water texture for the entire cylinder if it is possibe because It really looks very cool. (I attach the material code below… It is a very simple version of water material).
Do you think it is possible to get a seamless effect modifing this material?
I really want thank you so much for you help!! it is very appreciated!!