To the outside world and his millions of fans, he was known as the Prince of Darkness. Yet those closest to Ozzy saw a different side to the musician