Mulholland Drive runs along the top of the Hollywood Hills. From this point you have views of the San Fernando Valley to the north, and downtown Los Angeles, Hollywood, and Beverly Hills to the south. From the road, most of the views are obscured by private homes. There are a number of overlook spots that you can stop at.
The two best spots are the Hollywood Bowl overlook at 7036 Mulholland Drive, where you will be able to see downtown Los Angeles and Hollywood. The next spot is at 8401 Mulholland Drive, where you will get a very nice view of Burbank and the surrounding San Fernando Valley.