Depending on the level of dementia your DF has this may well be a care package provided by the local council, often called a 'reablement' package, if his level of need is higher then it may be an nhs funded package rather than council & would be more a care package pre him being ready for independence, the name of this varies from area to area, but will be along the lines of 'urgent care', both teams tend to work with clients for around 3-6 week, depending on area & need.
You can start with urgent care & then be referred on to reablement.
The level of care will be dependent on how your DF has been assessed in hosptial, some clients will get just a morning visit per day, if they just need a bit of help getting back into routine, others may need more, typically up to four times a day.
Carers will help with personal care, washing, dressing, meal prep and gradually try & encourage your DF to manage tasks on his own again.
The team deciding his discharge will also look at whether he needs help with things like housework/shopping etc... but this would normally be sourced from private agencies or charities like age concern so his funds may need to be assessed.
If he isn't independent after the initial support offered, some teams can extend & they won't just leave him without care, they will work with him & you as his family to assess his needs for ongoing support & help you find a private agency if needed.
Hope that makes sense & it does vary from area to area, all councils have an obligation to have some kind of service but it doesn't look the same across the country