The son of Grammy-winning R&B singer Usher nearly drowned in an Atlanta pool and is in hospital police have said.