If you want a bit of life, then the molesworth arms in town has rooms. Or at least they did a little while back.
If you want peace and quiet and can spend a bit, trewornan manor just outside Wadebridge is a lovely place to stay.
If all else fails, there's the Travelodge on the top of the hill.
The Pickwick inn in st issey is alright too.