High numbers of people in their 40s are being admitted to hospital for alcohol and drug abuse in the UK, while binge drinking is declining, a report has said.