The neighborhood that fits your desires exactly is Atwater Village. It's the nicest neighborhood in LA that has cafes, restaurants, post office, library, farmers market, bars, schools - all within easy walking distance.
Also, check out Eagle Rock, Highland Park. None of these are near the beach.