thank you for all your replies. the first reply is rather technical but I think I got the jist of it! and as for my mum's eyesight well thats poor but my 13yr old sister's is fine and im sure she'd take great delight in telling mum that golden boy isnt so golden haha! and your pretty much bang on with the pixel size and the 24" by 36" would be more than enough I was hoping for around 24" on the longest side.
thanks again!
Martin
There are a couple other considerations which probably work out in your favor.
Printing on a textured surface, such as canvas, reduces the amount of detail that can be seen. It works best for images that do not rely on sharpness for their appeal. Your image is, I think, a classic example of exactly that kind of an image. Imagine, for example, an oil painting of that scene on a 6' x 4' canvas! It would not require any significant fine detail, even if viewed from only 10 feet away.
It is virtually impossible to look at a 800x533 pixel image on a computer screen and determine how sharp it looks at the original 4000x2600 size, never mind when rescaled to be printed at a 24"x16" or larger size. Hence we
cannot tell if your image is sharp enough, and have to assume that it is. (Probably a very good assumption if you like the shot when looking at it close up.)
As far as technically how to get the best print... you need to find out the native pixel per inch value of the printer it will be done on. For example, Canon and HP printers use 300 PPI, Epson uses 360 PPI, and various commercial printers have other values, such as 204 PPI for a Fuji Lightjet.
You want to re-sample your image, at the native PPI of the printer, to be the right number of pixels for the size you want. Hence, a 24"x16" to be printed on a Lightjet at 204 PPI should be scaled to 4896x3264, but if it will be printed on an Epson 7900 at 360 PPI it should be scaled to 8640x5760.
Note that the amount of sharpening to apply to an image at 4896 pixels across and to the same image at 8640 pixels across is significantly different to get the same visual effect!
At that resolution it should be appropriately sharpened. To judge the sharpening you'll need to crop out a section of the print at approximately the PPI of your computer screen. If your screen is, for exampe 96 PPI and you can look at an image that is 15 inches wide on the screen, you'll want to zoom in to where you are viewing a 1440 pixel wide section of the image while adjusting how much sharpening to apply.
You will also find that using Unsharp Mask is not as effective for images that have been scaled up as it is for those that have been scaled down, while a high pass "sharpen" tool is more effective. Hence what you do to the image to make it look good for viewing on the web is very different that what makes it look good for printing at 24"x16".
Send the sharpened higher resolution version to the printer.
That sounds complicated, but if you read through it a couple times it is not difficult to follow the logic.
Another possibility is to make the original RAW file available for download, and I and perhaps others too, would be happy to "massage" it and provide a JPEG file that you can download and print. You would need to specify the physical size in inches (which must match the aspect ratio of your image, or you need to provide cropping instructions) and which type of printer it will be printed on.