What's the simplest way of calculating the optimum fee? For 'Satoshi per byte', is it possible to know how many bytes the transaction is likely to take?

Also, suppose the transaction is not urgent (say changing BTC between own wallets or sending to a relative), can it be sent with very low fee? What's the worse that can happen - will the transcation get cancelled/not go through on the blockchain?

Thanks!