Yes of course i need a chip /IC through in which the external circuitry i fixed a frequency and it work like as stand alone frequency generator.And give me a sine wave output .How do you intend to control the frequency? Potentiometer? I assume you've rejected the AD98XX chips because they require a microcontroller interface.
IC/Chip which can output a sine wave upto 30 MHz.A four pin IC/Chip?......... can generate sine wave standalone.