On the northern coast of Kyoto Prefecture, Amanohashidate (天橋立, Bridge to Heaven) as been rated for centuries as one of Japan's 'three great views'. The 'bridge' is really a 3.5km long, narrow sand spit covered with some 8000 pine trees, and there's a lot of activity near the southern end.
Otherwise the region is pretty spread out, and while there are buses, a rental car will save you time. Train service stops only near the main entrance to Amanohashidate. Amanohashidate is part of Miyazu City. Central Miyazu, about 5km east, has some inns, restaurants and a multistorey shopping centre with restaurants and a supermarket.