It can be harder to relax on holiday with small children, because you still have to do the work of looking after them, so holidays will generally be less indulgent (although, if you can team up with friends who have kids, you can take it in turns to escape and do grown-up things for a few hours). However, if you are quite childish yourself, this can be a great opportunity to do stuff you’d find hard to justify without children, such as fulfilling that long-held dream of going to LegoLand.
In the first few years it can be a good idea to not go too far for your holidays. Children get better at travelling as they get older, and early on all new places are interesting to them, so they won’t necessarily be more impressed by going to Barcelona than by going to Blackpool.