Depends what you want to do.
Some caravanners, like me, always use site with hook-ups - for them the smallest, cheapest car battery will do.
Most, however, spend some of their time off hook-up - a leisure battery is normally chosen 85-110Ah capacity because it handles the discharge much better than car batteries.