If you created a family, the whole family is deleted with every child's data. Otherwise only your login is deleted.
You have 14 days to change your mind: just sign in again. After that everything is erased for good.
Deleting your account doesn't cancel an App Store or Google Play subscription. Cancel it in your store's subscription settings.