It's not necessary to paint the bottom with antifouling paint if it will just be sitting in the water overnight. If you plan to leave it in the water for weeks, and longer, then yes.
Antifouling paint will slow you down a little, and might possibly be a negative to a future owner when you try to...